package com.site.dao;

import com.site.pojo.CircuitBoardSize;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

/**
 * FileName: CircuitBoardSizeDao.java
 * 电路板规格表Dao
 *
 * @author 田尚忠
 * @Date    2021/11/28
 * @version 1.00
 */
public interface CircuitBoardSizeDao {
    /*查询方法*/

        //查询全部
        List<CircuitBoardSize> selectAll() throws SQLException;

        //按照id查询
        CircuitBoardSize selectByid(int id) throws SQLException;

        //通过商品id查询
        List<CircuitBoardSize> selectByGoodsid(int id) throws SQLException;

        //按照信息进行查询
        CircuitBoardSize selectinfo(CircuitBoardSize circuitBoardSize) throws SQLException;

    /*增加方法*/

        //新增电路板规格
        int addCircuitBoardSize(CircuitBoardSize cableSize) throws SQLException;
        int addCircuitBoardSize(Connection conn,CircuitBoardSize cableSize);


    /*删除方法*/

        //通过id删除CircuitBoardSize
        int delCircuitBoardSizeByid(int id);
        int delCircuitBoardSizeByid(Connection conn, int id);

        //通过商品id删除CircuitBoardSize
        int delCircuitBoardSizeByGoodsid(int id);
        int delCircuitBoardSizeByGoodsid(Connection conn,int id);


    /*修改方法*/

        //通过id修改CircuitBoardSize
        int updateCircuitBoardSize(int id,CircuitBoardSize circuitBoardSize);
        int updateCircuitBoardSize(Connection conn,int id,CircuitBoardSize circuitBoardSize);
}
